Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	2824
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	286.8 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12

Alerts

`gross_revenue` is highly overall correlated with `qtde_invoices` and 3 other fields	High correlation
`qtde_invoices` is highly overall correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_itens` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_products` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly overall correlated with `u_basket_size`	High correlation
`avg_recency_days` is highly overall correlated with `frequency`	High correlation
`frequency` is highly overall correlated with `avg_recency_days`	High correlation
`basket_size` is highly overall correlated with `gross_revenue` and 1 other fields	High correlation
`u_basket_size` is highly overall correlated with `qtde_products` and 1 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 42.49949808)	Skewed
`frequency` is highly skewed (γ1 = 22.86486892)	Skewed
`qtde_returns` is highly skewed (γ1 = 21.82144361)	Skewed
`customer_id` has unique values	Unique
`recency_days` has 33 (1.2%) zeros	Zeros
`avg_recency_days` has 51 (1.8%) zeros	Zeros
`qtde_returns` has 1524 (54.0%) zeros	Zeros

Reproduction

Analysis started	2023-11-15 15:53:16.969602
Analysis finished	2023-11-15 15:54:16.631061
Duration	59.66 seconds
Software version	ydata-profiling vv4.6.1
Download configuration	config.json

customer_id
Real number (ℝ)

UNIQUE

Distinct	2824
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15299.481

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	12347
5-th percentile	12626.15
Q1	13826.25
median	15270.5
Q3	16801.75
95-th percentile	17953.55
Maximum	18287
Range	5940
Interquartile range (IQR)	2975.5

Descriptive statistics

Standard deviation	1714.421
Coefficient of variation (CV)	0.11205747
Kurtosis	-1.2049882
Mean	15299.481
Median Absolute Deviation (MAD)	1484
Skewness	0.0027127875
Sum	43205733
Variance	2939239.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
14655	1	< 0.1%
17029	1	< 0.1%
13220	1	< 0.1%
15985	1	< 0.1%
15172	1	< 0.1%
13692	1	< 0.1%
15745	1	< 0.1%
16639	1	< 0.1%
15491	1	< 0.1%
Other values (2814)	2814	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18265	1	< 0.1%
18263	1	< 0.1%
18261	1	< 0.1%
18260	1	< 0.1%

gross_revenue
Real number (ℝ)

HIGH CORRELATION

Distinct	2808
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2820.8528

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	36.56
5-th percentile	251.876
Q1	614.015
median	1142.935
Q3	2388.8375
95-th percentile	7433.5075
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1774.8225

Descriptive statistics

Standard deviation	10401.624
Coefficient of variation (CV)	3.687404
Kurtosis	375.53948
Mean	2820.8528
Median Absolute Deviation (MAD)	683.02
Skewness	17.129036
Sum	7966088.4
Variance	1.0819378 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1353.74	2	0.1%
734.94	2	0.1%
2092.32	2	0.1%
1078.96	2	0.1%
178.96	2	0.1%
2053.02	2	0.1%
745.06	2	0.1%
1025.44	2	0.1%
889.93	2	0.1%
598.2	2	0.1%
Other values (2798)	2804	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%
77.4	1	< 0.1%
84.65	1	< 0.1%
90.3	1	< 0.1%
93.35	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65039.62	1	< 0.1%

recency_days
Real number (ℝ)

ZEROS

Distinct	257
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58.105524

Minimum	0
Maximum	373
Zeros	33
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	74
95-th percentile	215
Maximum	373
Range	373
Interquartile range (IQR)	64

Descriptive statistics

Standard deviation	70.215004
Coefficient of variation (CV)	1.208405
Kurtosis	3.2614675
Mean	58.105524
Median Absolute Deviation (MAD)	24
Skewness	1.8722169
Sum	164090
Variance	4930.1468
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.5%
4	87	3.1%
2	86	3.0%
3	85	3.0%
8	76	2.7%
10	69	2.4%
9	66	2.3%
7	65	2.3%
17	62	2.2%
22	56	2.0%
Other values (247)	2073	73.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33	1.2%
1	99	3.5%
2	86	3.0%
3	85	3.0%
4	87	3.1%
5	43	1.5%
7	65	2.3%
8	76	2.7%
9	66	2.3%
10	69	2.4%

Value	Count	Frequency (%)
373	1	< 0.1%
372	1	< 0.1%
369	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%
337	1	< 0.1%
336	2	0.1%
334	1	< 0.1%

qtde_invoices
Real number (ℝ)

HIGH CORRELATION

Distinct	55
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.983711

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.0058675
Coefficient of variation (CV)	1.5050639
Kurtosis	186.37707
Mean	5.983711
Median Absolute Deviation (MAD)	2
Skewness	10.688153
Sum	16898
Variance	81.10565
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	825	29.2%
3	503	17.8%
4	394	14.0%
5	237	8.4%
6	173	6.1%
7	138	4.9%
8	98	3.5%
9	69	2.4%
10	55	1.9%
11	54	1.9%
Other values (45)	278	9.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	825	29.2%
3	503	17.8%
4	394	14.0%
5	237	8.4%
6	173	6.1%
7	138	4.9%
8	98	3.5%
9	69	2.4%
10	55	1.9%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

qtde_itens
Real number (ℝ)

HIGH CORRELATION

Distinct	1653
Distinct (%)	58.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1648.7755

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	2
5-th percentile	114.15
Q1	323
median	683.5
Q3	1468.25
95-th percentile	4538.4
Maximum	196844
Range	196842
Interquartile range (IQR)	1145.25

Descriptive statistics

Standard deviation	5840.5383
Coefficient of variation (CV)	3.5423491
Kurtosis	493.5989
Mean	1648.7755
Median Absolute Deviation (MAD)	441.5
Skewness	18.32383
Sum	4656142
Variance	34111888
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
150	8	0.3%
246	8	0.3%
219	7	0.2%
1200	7	0.2%
200	7	0.2%
493	7	0.2%
300	7	0.2%
272	7	0.2%
394	7	0.2%
Other values (1643)	2748	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
24	1	< 0.1%
25	1	< 0.1%
27	2	0.1%
30	1	< 0.1%
32	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%
50255	1	< 0.1%

qtde_products
Real number (ℝ)

HIGH CORRELATION

Distinct	467
Distinct (%)	16.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	128.23477

Minimum	2
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	2
5-th percentile	10
Q1	34
median	71
Q3	142
95-th percentile	393.7
Maximum	7838
Range	7836
Interquartile range (IQR)	108

Descriptive statistics

Standard deviation	275.58898
Coefficient of variation (CV)	2.1490971
Kurtosis	341.89962
Mean	128.23477
Median Absolute Deviation (MAD)	44
Skewness	15.455648
Sum	362135
Variance	75949.287
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	39	1.4%
35	36	1.3%
27	31	1.1%
26	31	1.1%
29	30	1.1%
31	28	1.0%
25	28	1.0%
15	28	1.0%
19	27	1.0%
33	26	0.9%
Other values (457)	2520	89.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	11	0.4%
3	13	0.5%
4	17	0.6%
5	16	0.6%
6	26	0.9%
7	15	0.5%
8	14	0.5%
9	20	0.7%
10	19	0.7%
11	23	0.8%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1944
Distinct (%)	68.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.976045

Minimum	2.15
Maximum	13305.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	2.15
5-th percentile	4.7615
Q1	12.21
median	17.89
Q3	24.8825
95-th percentile	87.165
Maximum	13305.5
Range	13303.35
Interquartile range (IQR)	12.6725

Descriptive statistics

Standard deviation	272.78159
Coefficient of variation (CV)	7.3772518
Kurtosis	2009.4589
Mean	36.976045
Median Absolute Deviation (MAD)	6.4
Skewness	42.499498
Sum	104420.35
Variance	74409.797
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.49	7	0.2%
17.66	6	0.2%
19.06	6	0.2%
16.53	6	0.2%
16.82	6	0.2%
17.13	5	0.2%
17.71	5	0.2%
10	5	0.2%
16.92	5	0.2%
19.44	5	0.2%
Other values (1934)	2768	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.15	1	< 0.1%
2.43	1	< 0.1%
2.46	1	< 0.1%
2.51	1	< 0.1%
2.52	1	< 0.1%
2.65	1	< 0.1%
2.66	1	< 0.1%
2.71	1	< 0.1%
2.76	1	< 0.1%
2.77	1	< 0.1%

Value	Count	Frequency (%)
13305.5	1	< 0.1%
4453.43	1	< 0.1%
1687.2	1	< 0.1%
1377.08	1	< 0.1%
952.99	1	< 0.1%
872.13	1	< 0.1%
841.02	1	< 0.1%
651.17	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%

avg_recency_days
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1218
Distinct (%)	43.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	73.078754

Minimum	0
Maximum	366
Zeros	51
Zeros (%)	1.8%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	0
5-th percentile	9.55
Q1	30
median	54
Q3	92.666667
95-th percentile	212.7
Maximum	366
Range	366
Interquartile range (IQR)	62.666667

Descriptive statistics

Standard deviation	65.524224
Coefficient of variation (CV)	0.89662482
Kurtosis	4.1469104
Mean	73.078754
Median Absolute Deviation (MAD)	28.703297
Skewness	1.9133911
Sum	206374.4
Variance	4293.424
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	51	1.8%
70	20	0.7%
31	20	0.7%
21	16	0.6%
14	16	0.6%
42	15	0.5%
55	15	0.5%
46	15	0.5%
49	14	0.5%
56	13	0.5%
Other values (1208)	2629	93.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	51	1.8%
0.0303030303	1	< 0.1%
0.2	1	< 0.1%
0.3333333333	1	< 0.1%
0.8571428571	1	< 0.1%
1	8	0.3%
1.5	1	< 0.1%
1.819512195	1	< 0.1%
1.878787879	1	< 0.1%
2	3	0.1%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1226
Distinct (%)	43.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.087058954

Minimum	0.0054495913
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	0.0054495913
5-th percentile	0.0088164204
Q1	0.015873016
median	0.024793388
Q3	0.043478261
95-th percentile	0.14937847
Maximum	17
Range	16.99455
Interquartile range (IQR)	0.027605245

Descriptive statistics

Standard deviation	0.43634384
Coefficient of variation (CV)	5.0120501
Kurtosis	810.31552
Mean	0.087058954
Median Absolute Deviation (MAD)	0.011000285
Skewness	22.864869
Sum	245.85449
Variance	0.19039595
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	47	1.7%
0.0625	18	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.6%
0.09090909091	15	0.5%
0.08333333333	15	0.5%
0.02941176471	14	0.5%
0.03448275862	14	0.5%
0.02564102564	13	0.5%
0.02127659574	13	0.5%
Other values (1216)	2642	93.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
4	1	< 0.1%
3	5	0.2%
2	47	1.7%
1.142857143	1	< 0.1%
1	8	0.3%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%

qtde_returns
Real number (ℝ)

SKEWED ZEROS

Distinct	204
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.408994

Minimum	0
Maximum	9014
Zeros	1524
Zeros (%)	54.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	8
95-th percentile	93.7
Maximum	9014
Range	9014
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	288.11229
Coefficient of variation (CV)	8.373168
Kurtosis	582.17626
Mean	34.408994
Median Absolute Deviation (MAD)	0
Skewness	21.821444
Sum	97171
Variance	83008.692
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1524	54.0%
1	131	4.6%
2	118	4.2%
3	82	2.9%
4	72	2.5%
6	63	2.2%
5	56	2.0%
12	46	1.6%
8	39	1.4%
9	38	1.3%
Other values (194)	655	23.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1524	54.0%
1	131	4.6%
2	118	4.2%
3	82	2.9%
4	72	2.5%
5	56	2.0%
6	63	2.2%
7	38	1.3%
8	39	1.4%
9	38	1.3%

Value	Count	Frequency (%)
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%
1594	1	< 0.1%

basket_size
Real number (ℝ)

HIGH CORRELATION

Distinct	1949
Distinct (%)	69.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	230.44568

Minimum	1
Maximum	6009.33
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	1
5-th percentile	44.033
Q1	102
median	171.04
Q3	277
95-th percentile	584.275
Maximum	6009.33
Range	6008.33
Interquartile range (IQR)	175

Descriptive statistics

Standard deviation	261.81746
Coefficient of variation (CV)	1.1361353
Kurtosis	113.6886
Mean	230.44568
Median Absolute Deviation (MAD)	81.375
Skewness	7.6467076
Sum	650778.6
Variance	68548.385
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
86	9	0.3%
60	8	0.3%
75	8	0.3%
197	7	0.2%
136	7	0.2%
105	7	0.2%
208	7	0.2%
82	7	0.2%
73	7	0.2%
Other values (1939)	2746	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3.33	1	< 0.1%
5.33	1	< 0.1%
5.67	1	< 0.1%
6.14	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%
11.88	1	< 0.1%

Value	Count	Frequency (%)
6009.33	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2733.94	1	< 0.1%
2518.77	1	< 0.1%
2160.33	1	< 0.1%
2082.23	1	< 0.1%
2000	1	< 0.1%
1903.5	1	< 0.1%
1866.93	1	< 0.1%

u_basket_size
Real number (ℝ)

HIGH CORRELATION

Distinct	982
Distinct (%)	34.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.109285

Minimum	1
Maximum	299.71
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.1 KiB

Quantile statistics

Minimum	1
5-th percentile	3.4745
Q1	10.1125
median	17.25
Q3	28.0275
95-th percentile	56.6655
Maximum	299.71
Range	298.71
Interquartile range (IQR)	17.915

Descriptive statistics

Standard deviation	18.850429
Coefficient of variation (CV)	0.85260237
Kurtosis	23.865882
Mean	22.109285
Median Absolute Deviation (MAD)	8.25
Skewness	3.1336106
Sum	62436.62
Variance	355.33866
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	45	1.6%
11	31	1.1%
14	31	1.1%
9	27	1.0%
1	27	1.0%
7.5	27	1.0%
10.5	26	0.9%
17.5	26	0.9%
17	24	0.8%
9.5	24	0.8%
Other values (972)	2536	89.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	27	1.0%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.33	2	0.1%
1.5	7	0.2%
1.57	2	0.1%
1.67	4	0.1%
1.83	1	< 0.1%
2	22	0.8%
2.05	1	< 0.1%

Value	Count	Frequency (%)
299.71	1	< 0.1%
203.5	1	< 0.1%
145	1	< 0.1%
136.12	1	< 0.1%
135.5	1	< 0.1%
122	1	< 0.1%
118	1	< 0.1%
114	1	< 0.1%
110.33	1	< 0.1%
110	1	< 0.1%

Auto

Heatmap
Table

	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_itens	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	basket_size	u_basket_size
customer_id	1.000	-0.094	0.014	0.004	-0.085	0.008	-0.146	-0.032	0.027	-0.062	-0.123	0.007
gross_revenue	-0.094	1.000	-0.379	0.764	0.920	0.720	0.283	-0.343	0.214	0.463	0.604	0.280
recency_days	0.014	-0.379	1.000	-0.453	-0.372	-0.398	0.032	0.188	-0.097	-0.189	-0.111	-0.111
qtde_invoices	0.004	0.764	-0.453	1.000	0.705	0.659	0.099	-0.453	0.272	0.431	0.134	0.018
qtde_itens	-0.085	0.920	-0.372	0.705	1.000	0.708	0.202	-0.318	0.199	0.425	0.763	0.312
qtde_products	0.008	0.720	-0.398	0.659	0.708	1.000	-0.374	-0.286	0.169	0.328	0.407	0.723
avg_ticket	-0.146	0.283	0.032	0.099	0.202	-0.374	1.000	-0.069	0.063	0.196	0.202	-0.623
avg_recency_days	-0.032	-0.343	0.188	-0.453	-0.318	-0.286	-0.069	1.000	-0.971	-0.216	-0.027	0.062
frequency	0.027	0.214	-0.097	0.272	0.199	0.169	0.063	-0.971	1.000	0.152	0.008	-0.072
qtde_returns	-0.062	0.463	-0.189	0.431	0.425	0.328	0.196	-0.216	0.152	1.000	0.212	0.022
basket_size	-0.123	0.604	-0.111	0.134	0.763	0.407	0.202	-0.027	0.008	0.212	1.000	0.431
u_basket_size	0.007	0.280	-0.111	0.018	0.312	0.723	-0.623	0.062	-0.072	0.022	0.431	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_itens	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	basket_size	u_basket_size
0	17850	5391.21	372.0	34.0	1733.0	297.0	18.15	0.030303	17.000000	40.0	50.97	8.74
1	13047	3232.59	56.0	9.0	1390.0	171.0	18.90	39.625000	0.028302	35.0	154.44	19.00
2	12583	6705.38	2.0	15.0	5028.0	232.0	28.90	26.500000	0.040323	50.0	335.20	15.47
3	13748	948.25	95.0	5.0	439.0	28.0	33.87	69.500000	0.017921	0.0	87.80	5.60
4	15100	876.00	333.0	3.0	80.0	3.0	292.00	20.000000	0.073171	22.0	26.67	1.00
5	15291	4623.30	25.0	14.0	2102.0	102.0	45.33	26.769231	0.040115	29.0	150.14	7.29
6	14688	5630.87	7.0	21.0	3621.0	327.0	17.22	18.300000	0.057221	399.0	172.43	15.57
7	17809	5411.91	16.0	12.0	2057.0	61.0	88.72	32.454545	0.033520	41.0	171.42	5.08
8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.54	4.144444	0.243316	474.0	419.71	26.14
9	16098	2005.63	87.0	7.0	613.0	67.0	29.93	47.666667	0.024390	0.0	87.57	9.57

	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_itens	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	basket_size	u_basket_size
5637	17468	137.00	10.0	2.0	116.0	5.0	27.40	4.000000	0.400000	0.0	58.00	2.5
5648	13596	697.04	5.0	2.0	406.0	166.0	4.20	7.000000	0.250000	0.0	203.00	83.0
5654	14893	1237.85	9.0	2.0	799.0	73.0	16.96	2.000000	0.666667	0.0	399.50	36.5
5656	17852	114.34	11.0	2.0	53.0	24.0	4.76	0.000000	2.000000	0.0	26.50	12.0
5673	17772	182.77	10.0	2.0	58.0	53.0	3.45	0.000000	2.000000	0.0	29.00	26.5
5679	14126	706.13	7.0	3.0	508.0	15.0	47.08	1.500000	0.750000	50.0	169.33	5.0
5680	16479	300.83	10.0	2.0	102.0	35.0	8.60	0.000000	2.000000	0.0	51.00	17.5
5685	13521	1092.39	1.0	3.0	733.0	435.0	2.51	4.500000	0.300000	0.0	244.33	145.0
5695	15060	301.84	8.0	4.0	262.0	120.0	2.52	0.333333	2.000000	0.0	65.50	30.0
5765	16000	12393.70	2.0	3.0	5110.0	9.0	1377.08	0.000000	3.000000	0.0	1703.33	3.0

Overview

Variables

Interactions

Correlations

Missing values

Sample